<!DOCTYPE HTML>
<html>
<head>
<meta charset="UTF-8">
<title>数据库导表</title>
<style type="text/css">
* {
	margin: 0;
	padding: 0;
}

.container {
	padding: 10px;
}

.clear {
	clear: both;
}
</style>

</head>
<body>
	<div class="container">
		<div>
			数据库:
			<select id="fromBaseId"  style="width: 200px;height: 23px;">
				<#list fromBase as database>
				<option value="${database.id}">${database.name}</option>
				</#list>
			</select>
			
			
			源表名:
			<input type="text" id="fromTable" style="width: 300px;height: 20px;" placeholder="例: schema.table">
			
			目标表:
			<input type="text" id="toTable"  style="width: 300px;height: 20px;" placeholder="例: schema.table">
			
			主键:
			<input type="text" id="mainKey"  style="width: 300px;height: 20px;" placeholder="">
		</div>

		
		<div style="margin-top: 10px;">
			<button type="button" onclick="build()" style="width: 100px;">生成sql</button>
		</div>
		
		<div style="margin-top: 10px;">
			<textarea id="sqlDel" style="width: 100%;height: 20px;background-color: #efefef;"></textarea>
		</div>
		
		<div style="margin-top: 10px;">
			<textarea id="sql" style="width: 100%;height: 600px;background-color: #efefef;"></textarea>
		</div>
	</div>

	<script type="text/javascript" src="../jquery-3.4.1.min.js"></script>
	<script type="text/javascript" src="../transTable/index.js?v=${jsrandom}"></script>
</body>
</html>
